Entity Relationships - Vacancies (VACANCY)

Related Tables

Table Name	Table Description	Primary Keys	Usually Joins From	Join Type	Joins On	Details
VACANCY	Vacancies	VACANCYID				Stores basic details about vacancies.
TRVACANCY	Trainee-Vacancy Link	TRVACANCYID, TRAINEEID	VACANCY	One to many	VACANCYID	Links trainees to vacancies.
VACASSESSOR	Assessor-Vacancy Link	VACASSESSORID	VACANCY	One to one	VACANCYID	Links assessors to vacancies.
VACATTRIB	Vacancy Attributes	VACANCYID, VACATTRIBID	VACANCY	One to many	VACANCYID	VACANCYID
VACEVENTS	Vacancy Events	VACEVENTID	VACANCY	One to many	VACANCYID	Lists events associated with a trainee's vacancy application process.